<html>
<head>


<title>Dokumentacija</title>

<link href="style/style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
p.MsoNormal {
margin-top:0cm;
margin-right:0cm;
margin-bottom:10.0pt;
margin-left:0cm;
line-height:115%;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
}
-->
</style>
</head>

<body><script type="text/javascript" src="scripts/steffie.js"></script>
<script type="text/javascript" src="scripts/stlib.js"></script>
<script type="text/javascript" src="scripts/sttree.js"></script>
<script type="text/javascript" src="scripts/tree.js"></script>

<div class="container">
 
  <div class="content">
    <code><h1 align="center">dohvati_aktivne_vozace</h1></code>
    <h3>OPIS </h3>
    <p>Procedura <code>dohvati_aktivne_vozace</code> dohva&#263;a listu voza&#269;a s aktivnim statusom iz tablice<code> vozaci</code>.</p>
    <HR>
    <h3>Sintaksa</h3><center>
    <table width="831" height="204" border="1">
      <tr>
        <th width="821" scope="col"><p align="left" class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;text-autospace:none;">&nbsp;</p>
          <p align="left" class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;text-autospace:none;"><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">DROP</span> <span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">PROCEDURE</span> <span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">IF</span> <span style="font-family:'Courier New'; font-size:10.0pt; color:gray; ">EXISTS</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> unidu_rezervacija.dohvati_aktivne_vozace</span><span style="font-family:'Courier New'; font-size:10.0pt; color:gray; ">;</span> </p>
          <p align="left" class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;text-autospace:none;"><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">CREATE</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> </span><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">PROCEDURE</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> unidu_rezervacija.`dohvati_aktivne_vozace`()</span></p>
          <p align="left" class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;text-autospace:none;"><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">BEGIN</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> </span></p>
          <p align="left" class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;text-autospace:none;"><span style="font-family:'Courier New'; font-size:10.0pt; color:black; ">&nbsp; </span><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">SELECT</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> </span><span style="font-family:'Courier New'; font-size:10.0pt; color:gray; ">*</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> </span></p>
          <p align="left" class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;text-autospace:none;"><span style="font-family:'Courier New'; font-size:10.0pt; color:black; ">&nbsp;&nbsp;&nbsp; </span><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">FROM</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> vozaci</span></p>
          <p align="left" class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;text-autospace:none;"><span style="font-family:'Courier New'; font-size:10.0pt; color:black; ">&nbsp;&nbsp; </span><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">WHERE</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> STATUS </span><span style="font-family:'Courier New'; font-size:10.0pt; color:gray; ">=</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> </span><span style="font-family:'Courier New'; font-size:10.0pt; color:red; ">'A'</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> </span></p>
          <p align="left" class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;text-autospace:none;"><span style="font-family:'Courier New'; font-size:10.0pt; color:black; ">&nbsp; </span><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">ORDER</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> </span><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">BY</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> PREZIME, IME</span><span style="font-family:'Courier New'; font-size:10.0pt; color:gray; ">;</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> </span></p>
          <p align="left" class="MsoNormal" style="margin-bottom:.0001pt;line-height:normal;text-autospace:none;"><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">END</span><span style="font-family:'Courier New'; font-size:10.0pt; color:gray; ">;</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> </span></p>
        <p align="left" class="MsoNormal">&nbsp;</p>          <br></th>
      </tr>
    </table></center>
    <code><p>&nbsp;</p></code>
    <HR> 
    <h3>Parametri</h3>
     <p>Nema parametara.</p>
     <HR> 
    <h3>Povratne vrijednosti</h3>
      <p>Nema povratnih vrijednosti.</p>
      <HR> 
    <h3>Bilje&Scaron;ke      </h3><center>
    <p align="left">Ako &#382;elimo dodati kratak komentar procedure unutar samoga koda potrebno je prije <code>BEGIN</code> dijela dodati sljede&#263;u liniju:    </p>
    <table width="832" border="1">
        <tr>
          <th width="822" scope="col"><p align="justify" class="MsoNormal"><span style="line-height:115%; font-family:'Courier New'; font-size:10.0pt; color:black; ">COMMENT </span><span style="line-height:115%; font-family:'Courier New'; font-size:10.0pt; color:red; ">'Procedura za dohvat  liste aktivnih voza&#269;a iz tablice vozaci'</span><span style="line-height:115%; font-family:'Courier New'; font-size:10.0pt; color:gray; ">;</span> </p></th>
        </tr>
    </table></center>
    <p align="left">&nbsp;</p>
    <p>Osim navedene linije, za prikaz komentara potrebno je dodati naredbu:    </p>
    <center>
      <table width="833" height="37" border="1">
      <tr>
        <th width="823" height="23" scope="col"><div align="left"><span class="MsoNormal"><span style="line-height:115%; font-family:'Courier New'; font-size:10.0pt; color:blue; ">SHOW</span><span style="line-height:115%; font-family:'Courier New'; font-size:10.0pt; color:black; "> </span><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">CREATE</span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; "> </span><span style="font-family:'Courier New'; font-size:10.0pt; color:blue; ">PROCEDURE </span><span style="font-family:'Courier New'; font-size:10.0pt; color:black; ">unidu_rezervacija.dohvati_aktivne_vozace</span><span style="line-height:115%; font-family:'Courier New'; font-size:10.0pt; color:gray; ">;</span></span></div></th>
      </tr>
  </table></center>
    <p>&nbsp;</p>
    <HR> 
    <h3>Primjer kori&Scaron;TENJA    </h3>
    <center>
      <table width="835" height="37" border="1">
      <tr>
          <th width="825" scope="col"><div align="justify"><span style="line-height:115%; font-family:'Courier New'; font-size:10.0pt; color:blue; ">CALL</span><span style="line-height:115%; font-family:'Courier New'; font-size:10.0pt; color:black; "> dohvati_aktivne_vozace()</span><span style="line-height:115%; font-family:'Courier New'; font-size:10.0pt; color:gray; ">;</span></div></th>
      </tr>
  </table></center>
      <p>&nbsp;</p>
       <HR> 
      <h3>Vidjeti tako&#272;er</h3>
     
    <p>Napomena: Broj znakova komentara procedure unutar koda je ograni&#269;en !</p>
 <HR> 
</div>
</div>
</body>
</html>
